﻿CREATE TABLE [dbo].[ASMS_PackagePurchaseBill]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Number] nvarchar(64) NOT NULL,
	[CustomerId] uniqueidentifier not null,
	[PackageId] uniqueidentifier not null,
	[BoughtDate] datetime not null,
	[BoughtChannel] nvarchar(64) not null,
	[BoughtPrice] money not null,
	[BusinessId] uniqueidentifier,
	[StationId] uniqueidentifier,
	[PaidAmount] money,
	[PaidTime] datetime,
	[SalesManagerId] uniqueidentifier,
    [SalesCommissionAmount] money not null,
	[Memo] nvarchar(256),
	[InvoiceType] nvarchar(64),
	[InvoiceNumber] nvarchar(64),
    [Cashier] nvarchar(64),
	[Status] int not null,
	[Creator] nvarchar(64) not null,
	[CreatedTime] datetime not null
)
